MacWorld 1999 May

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1999 May / Macworld (1999-05).dmg / Shareware World / Utilities / Data & Time / SQLPlugin / SQL Example / Artists.fp3 (.txt) next >

Wrap

FileMaker Pro Database | 1999-02-10 | 152KB | 1,060 lines

Copyright 1984-1998 FileMaker, Inc. HBAM2016AUG95 Pro 3.0 HBAM3016AUG95@ UXGSPNGXPPRVNMCDUa\N@OJQJTfmjIEN_PUNW?HOd^G<D_[S:@KRdS`[_SGK\TTCPO[TUMOJB@FQQ^eul`XQ[\XPPRVNMCDUa\N@OJQJTfmjIEN_PUNW?HOd^G<D_[NK LPVOCDQ]_WUV][eXSGKPAKALCHEKZ 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2/10/99 ARTIST NUMBER CATEGORY CONSTANT COUNTLINES FIRST NAME INSERT STRING ODBC DATASOURCE PASSWORD SQL STATEMENT STATUS SURNAME USERNAME Artist numberB First NameB SurnameB CategoryB statusB insert stringB odbc datasourceB UsernameB PasswordB Sql statementB ConstantB CountlinesB DataB rowsB create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12) , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) ) Intro Populate Create Query 3 Query 2 A Adres pdm Rumora info A Help.menu Help.intro Help.create Help.populate Help.query2 Help.query3 "Insert into artists values ( '" & & "','" & "''") & "','" & "''") & "','" & "''") & "' )" Insert into artists values ( ' IntroB PopulateB Filemaker Pro ODBC/SQL PluginY7100 % Cross Platform (Macintosh AND Windows 95, 98, NT)Z High Performance[,Fast Implementation in existing environments\ Connects to ANY ODBC Datasource A=Import, Export, update, select data. Create views and Reports ^0Perform SQL Statements from within Filemaker Pro_&Export directly to TAB separated files`,Build live connections with ODBC Datasourcesa MENUg INTROh CREATEi POPULATEj QUERYk UPDATEl Help & more info CreateB Artist numberD First NameF SurnameH CategoryU Insert stringW database statusi MENUo INTROp CREATEq POPULATEr QUERYs UPDATEt Local Filemaker Pro data Populate table artists~'note: this string is a caculation field Populate table artworks Help & more info Artist numberD First NameF SurnameH CategoryU Insert stringW database statusi MENUo INTROp CREATEq POPULATEr QUERYs UPDATEt Local Filemaker Pro data Populate table artists~'note: this string is a caculation field Populate table artworks Help & more info Query 3B SQL statement:D database status:E MENUK INTROL CREATEM POPULATEN QUERYO UPDATEP Create table artistsS odbc datasourceU usernameW passwordX Connect[ Help & more infoh Create table artworks Query 2B rowcount Artwork noK TitleL PriceN Artist noO First nameP SurnameR StatusS MENUW INTROX CREATEY POPULATEZ QUERY 3[ UPDATE\ GET ALL^ Select statement_ Help & more info MenuB Select statementD DataE MENUJ INTROK CREATEL POPULATEM QUERY 2N UPDATEO EXEC QUERYQ GET ROWR GET COLUMNU StatusV Help & more info A Adres pdmB [tProfessional Data Management Algolweg 20 3821 BH Amersfoort THE NETHERLANDS Tel. +31 33 4566183 Fax. +31 33 4566184 MENUG INTROH CREATEI POPULATEJ QUERYK UPDATEL MENUG INTROH CREATEI POPULATEJ QUERYK UPDATEL This demonstration file shows different ways of using and programming the ODBC/SQL Plugin. Every now and then there will be new versions on our website of this files. Keep in touch! Make sure you have the font Verdana installed for best viewing Navigation tip: Follow the navigation in the tabs above from left to right to create everything in the right order All databases are fully unlocked. All databases may be used in own projects except database design. All design is (C)opyright of ProB*fessional Data Management, The Netherlands NAWindows version: (click logo for address and contact information)OCMacintosh version: (click logo for address and contact information)P0This is a DEMONSTRATION file. Usage at own risk.Q Help & more infoR Demo version 1.0 Rumora infoB Rumora Automatisering en Advies Buiksloterdijk 212-214 1025 WD AMSTERDAM The Netherlands. Tel (+3120) 4940804, mobile phone (+316) 53460626, fax (+3120) 4940805. Technical support: bane@xs4all.nl. Back to menu A Help.menuB Support: (Windows only, Macintosh support is done by Rumora) Preffered via e-mail: support@profdata.nl If necessary you can call us our time zone is Central Europe (GMT + 1) For U.S.A residents this means that if you want to call us, call us early in the morning. Professional Data Mangement is specialized in: - Filemaker Pro solutions - Filemaker Pro plugins (also custom made plugins) - E-commerce solutions (Filemaker Pro, Lotus Domino, MS SQL Server, Broadvision) - Internet related databases - JAVA programming_ Back to menu` Internet: http://www.profdata.nl Help.introB BackB0On nearly every screen you will see the button: C Help & more info EOby pressing this button you will get more information on what is on that layout This demofile creates two tables in your datasource. It was built using MS SQL Server. If you use another datasource (like Oracle you might need to edit some SQL statements according to the specifications of your datasource. On the screens that use SQL statements there will be some additional information on how to do this. Although this demonstration files have been thoroughly tested we can not guarrantee that they work correctly. Help.createB BackB0On nearly every screen you will see the button: C Help & more infoEOby pressing this button you will get more information on what is on that layout @NOTE: The plugin is NOT an ODBC driver. With the plugin you will not be able to allow other applications to access Filemaker Pro files. At this moment there is only one option if you really need Filemaker data to be ODBC accessible . Do the following: Use the plugin to update a datasource and access that datasource. Help.populateB BackB0On nearly every screen you will see the button: C Help & more infoEOby pressing this button you will get more information on what is on that layout Before you create tables you have to make an ODBC datasource (if you don t have one yet) Please follow the instructions that come with your ODBC software on how to accomplish this. After creating the datasource enter the name of the datasource into the Filemaker Pro field and, if necessary, also enter the login information. If you have access to a MS SQL Server, please use it. This file was created and tested with MS SQL 6.5 and 7. You can try anyway. It will work with most datasources When you click on create the first table Artists will be created. In the table artists we will put information on artists. The second table to be created is Artworks . Click again on create to accomplish this. If you get error messages: First enable Error reporting (first script under the script menu) and try to figure out what the error is by reading the error message window. - You might not have connected to the datasource - Maybe the table(s) allready exist? - Maybe your datC,asource is incompatible with the field types Help.query2B BackB0On nearly every screen you will see the button: C Help & more infoEOby pressing this button you will get more information on what is on that layout wThe table artists and artworks are filled with data from the Filemaker table artists and artworks. This is done by using a calculated INSERT statement (have a look a the calculation field insert string). By looping through all records all data is inserted into the table. If you get errors check this: - Did you connect to your datasource? - Did you create both tables? Help.query3B BackB0On nearly every screen you will see the button: C Help & more infoEOby pressing this button you will get more information on what is on that layout On this layout you can query the database yourself or use the sample query that is in the field SQl statement (Select statement). You can retrieve one row at a time (Get Row) or you can get one Column at a time (GetColumn) AartsH Contemporary Modern ArtO 1Q 010114109 BertD AbbingH Contemporary Modern ArtO DeliaD AlbersenH Contemporary Modern ArtO GerritD AlbertsH Contemporary Modern ArtO AlbertsH Contemporary Modern ArtO SaadD Contemporary Modern ArtO KarelD AppelH Classical ModernO ArjanD Van ArendonkH Contemporary Modern ArtO ArmanH Classical ModernO ArmandoH Classical ModernO MarianneD AulmanH Contemporary Modern ArtO JokeD BaasH Contemporary Modern ArtO PeterD BastiaansenH Contemporary Modern ArtO PaulD BeckersH Contemporary Modern ArtO CarlosD BeukenH Contemporary Modern ArtO De BeusH Contemporary Modern ArtO TreesD BoerH Contemporary Modern ArtO IlseD De BoerH Contemporary Modern ArtO GorkiD BollarH Contemporary Modern ArtO BackB0On nearly every screen you will see the button: C Help & more infoEOby pressing this button you will get more information on what is on that layout On this layout you can query the database yourself or use the sample query that is in the field SQl statement (Select statement). This demo will export the found set to your local drive. And import the result into the line items file li.fp3. This is the fastest way to get large amount of data inside filemaker On Windows all data is exported to C:\TEMPF.TAB. You can delete this file afterwards if you want to. OlgaD BontekoeH Contemporary Modern ArtO HermanD Van De BoomH Contemporary Modern ArtO JacquelineD Van De BosH Contemporary Modern ArtO KarinD Contemporary Modern ArtO 113B WillemijnD BoumanH Contemporary Modern ArtO EelcoD BrandH Contemporary Modern ArtO AdaD BreedveldH Contemporary Modern ArtO BuismanH Contemporary Modern ArtO MoriD BundH Contemporary Modern ArtO LynnD ChadwickH Classical ModernO MarcD ChagallH Classical ModernO 148B DominiqueD ChanH Contemporary Modern ArtO PierreD CopsH Contemporary Modern ArtO Contemporary Modern ArtO DanielD CouetH Contemporary Modern ArtO ColetteD CurfsH Contemporary Modern ArtO GeorgeD dEspagnatH Classical ModernO HansD DeussH Contemporary Modern ArtO DiekstraH Contemporary Modern ArtO HennieD Van Diest Error reporting on Startup script ***** NAVIGATION SCRIPTS ***** Insert row Insert all artists G: Layout Populate goto query1 G: Intro G: Create G: Populate G: Query 1 G: Query 2 G: Query 3 G: Update G: UI G: Menu Connect Execute statement Create table artists Create table artworks Contemporary Modern ArtO EvertD Van DijkH Contemporary Modern ArtO PaulD DijkmanH Contemporary Modern ArtO Van DoeselaarH Contemporary Modern ArtO DoraD DolzH Contemporary Modern ArtO XandraD DondersH Contemporary Modern ArtO BartD DrostH Contemporary Modern ArtO JeanD DubuffetH Classical ModernO LitaD Van EngelenhovenH Contemporary Modern ArtO Van EsH Contemporary Modern ArtO FrankD Van EyndhovenH Contemporary Modern ArtO LeonorD FiniH Classical ModernO RobertD FortgensH Contemporary Modern ArtO 513B TsuguharuD FoujitaH Classical ModernO FlipD GaasendamH Contemporary Modern ArtO JolandeD GernerH Contemporary Modern ArtO HarrieD GerritzH Contemporary Modern ArtO CarolienD GeversH Contemporary Modern ArtO GijzenH Contemporary Modern Art SietseD GovertsH Contemporary Modern ArtO 140B AnnemarieD De GrootH Contemporary Modern ArtO GrotenbregH Contemporary Modern ArtO JurjenD De HaanH Contemporary Modern ArtO LetitiaD De HaasH Contemporary Modern ArtO DianeD Van HalH Contemporary Modern ArtO FerryD HalewijnH Contemporary Modern ArtO ElmaD Van HarenH Contemporary Modern ArtO PattyD HarpenauH Contemporary Modern ArtO HenriD HaydenH Classical ModernO JozinaD HeesH Contemporary Modern ArtO BethuelD HeldtH Contemporary Modern ArtO OttoD HetterscheidH Contemporary Modern ArtO EricD HirdesH Contemporary Modern ArtO Hans P.D Innem Contemporary Modern ArtO DagmarD Contemporary Modern ArtO RityD Jansen-HeijtmajerH Contemporary Modern ArtO LeonD JanssenH Contemporary Modern ArtO AlexejD Von JawlenskyH Classical ModernO MichaelD JepkesH Contemporary Modern ArtO FredD De JongH Contemporary Modern ArtO 073B LambertusD De JongH Contemporary Modern ArtO AsgerD JornH Classical ModernO HugoD KaagmanH Contemporary Modern ArtO KlementH Contemporary Modern ArtO DorritD KlompH Contemporary Modern ArtO SjaakD KorstenH Contemporary Modern ArtO HenkD KristH Contemporary Modern ArtO ToonD KuijpersH Contemporary Modern ArtO 055B Anne-loreD KuryszczukH Contemporary Modern ArtO MarcD KuyperH Contemporary Modern ArtO LaimbockH Contemporary Modern ArtO RuudD LanfermeijerH Contemporary Modern ArtO AndreD LanskoyH Classical ModernO AtiD LichtveldH Contemporary Modern ArtO FrankD LisserH Contemporary Modern ArtO MarkD LisserH Contemporary Modern ArtO Peter LoumanH Contemporary Modern ArtO MaximilienD LuceH Classical ModernO AbrahamD ttgerH Contemporary Modern ArtO AnnekeD Van De MandeleH Contemporary Modern ArtO AdrieD MartensH Contemporary Modern ArtO AndreD MassonH Classical ModernO BeatriceD Mc Sorley / de JongH Contemporary Modern ArtO EritiaD Van Der MeiH Contemporary Modern ArtO SamD MiddletonH Contemporary Modern ArtO ConstantijnD MolenkampH Contemporary Modern ArtO MarionD MolierH Contemporary Modern ArtO NellaD MontfoortH Contemporary Modern ArtO PjotrD Van MoockH Contemporary Modern ArtO MarcoD MuusseH Contemporary Modern ArtO NicolasH Contemporary Modern ArtO JeanD Le NobleH Contemporary Modern ArtO LydiaD OerlemansH Contemporary Modern ArtO VincentD Van OjenH Contemporary Modern ArtO OldenhofH Contemporary Modern ArtO HenkD OlijveH Contemporary Modern ArtO GertD OortmerssenH Contemporary Modern ArtO SylviaD OudkerkH Contemporary Modern ArtO JilleD Van De PasH Contemporary Modern ArtO SaskiaD PfaeltzerH Contemporary Modern ArtO SariD PiekH Contemporary Modern ArtO TheodoraD Van Der PlasH Contemporary Modern ArtO SimonD PosthumaH Contemporary Modern ArtO FineD PrastH Contemporary Modern ArtO HenkD Van PuttenH Contemporary Modern ArtO LiesbethD RahderH Contemporary Modern ArtO RamirezD RamirezH Contemporary Modern ArtO WalterD RastH Contemporary Modern ArtO MonicaD Van RijnH Contemporary Modern ArtO JacquelineD Van RosmalenH Contemporary Modern ArtO 166B Dadara D.D RozenbergH Contemporary Modern ArtO IngeD SchagenH Contemporary Modern ArtO WillemD Van ScheijndelH Contemporary Modern ArtO MattieD SchildersH Contemporary Modern ArtO 185B Margreet D ScholtenH Contemporary Modern ArtO PeterD SchruijrenH Contemporary Modern ArtO NickD SeijkensH Contemporary Modern ArtO PaulD SmuldersH Contemporary Modern ArtO PeterD SpaansH Contemporary Modern ArtO 051B HenrietteD SpieringH Contemporary Modern ArtO 052B ChristineD SpieringsH Contemporary Modern ArtO HermanD StaalduinenH Contemporary Modern ArtO StallenbergH Contemporary Modern ArtO Van SteenselH Contemporary Modern ArtO JolandeD StilH Contemporary Modern ArtO JacquesD TangeH Contemporary Modern ArtO FransD Van TartwijkH Contemporary Modern ArtO Lou D ThissenH Contemporary Modern ArtO EricD ToeboschH Contemporary Modern ArtO Ronald D Tolman Contemporary Modern ArtO EllenD Van ToorH Contemporary Modern ArtO MauriceD UtrilloH Classical ModernO HennieD Van der VegtH Contemporary Modern ArtO HansD VanhorckH Contemporary Modern ArtO RuudD VerkerkH Contemporary Modern ArtO 130B Ramon JanD Contemporary Modern ArtO Volger/van HarenH Contemporary Modern ArtO IljaD WalravenH Contemporary Modern ArtO C.A.D WertheimH Contemporary Modern ArtO LeoD WijnhovenH Contemporary Modern ArtO MeikinaD WilgenkampH Contemporary Modern ArtO Bert D WilsH Contemporary Modern ArtO BertD Van ZelmH Contemporary Modern ArtO MajaD ZomerH Contemporary Modern ArtO Helvetica Geneva Times Palatino Arial Verdana Insert all artworks Execute query Get Column Get Row Query3 OnClose Insert all artists Yes Lov'it Noease Yes Lov'it Are you sure you want to insert all the artist recordst to the artists table? (make sure you have allready created the table)B, ) = 2 |("SQL-doSQL" SQL-doSQL = "OK" Insert row |("SQL-doSQL" SQL-doSQL G: Layout Populate goto query1 Startup script ***** NAVIGATION SCRIPTS ***** A0THIS IS NOT A SCRIPT BUT JUST A SCRIPT SEPARATOR G: Intro A G: Create ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numWe're ready! Everything went fine!F onds ( time ) Sign ( numb Cancelin ( number ) Sqrt ( numbe Status ( status flag ) StDevSomething went wrong! Please enable error reporting (scriptmenu) and check the error! G: Populate G: Query 1 G: Query 1 in Artworks G: Query 2 "SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))" SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%')) G: Query 3 w"create table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42) , category varchar(60) )" ucreate table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42) , category varchar(60) ) "create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12) , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )" create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12) , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) ) A G: Update G: Update in Artworks G: UI G: UI in Artworks G: Menu Connect |("SQL-open" SQL-open |("SQL-open" SQL-open |("SQL-open" & "|" & SQL-open |("SQL-open" & "|" & & "|" & SQL-open Execute statement "SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))" SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%')) Error reporting on |("SQL-enableReporting" "1") SQL-enableReporting Create table artists ax ( field... ) Middle ( Noncelstart ; size )7 MiddleWords ( text ; starting word ; number oDo you want to create the table artists now?B, ) = 1 w"create table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42) , category varchar(60) )" ucreate table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42) , category varchar(60) )D9 |("SQL-doSQL" SQL-doSQL = "OK" |("SQL-doSQL" SQL-doSQL Create table artworks ax ( field... ) Middle ( Noncelstart ; size )7 MiddleWords ( text ; starting word ; number oDo you want to create the table artworks now?B, ) = 1 "create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12) , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )" create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12) , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) ) |("SQL-doSQL" SQL-doSQL ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numThe table has been correctly createdG ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numSomething went wrong! Enable error reporting for details! Insert all artworks Yes Lov'it Noease Yes Lov'it Are you sure you want to insert all the records of artworks in your datasource? It could take some time, please be patient (nearly 2000 records)B, ) = 2 Insert all in artworksD- = "OK" ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numWe're ready! Everything went fine!F onds ( time ) Sign ( numb Cancelin ( number ) Sqrt ( numbe Status ( status flag ) StDevSomething went wrong! Please enable error reporting (scriptmenu) and check the error! Execute query = "OK" ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numThe table has been correctly createdG ivisor ) Month ( date ) Cancelme ( date ) NPV ( payment interest rate ) NumToText ( numSomething went wrong! Enable error reporting for details! |("SQL-execQuery" SQL-execQuery Get Column |("SQL-getColumn" SQL-getColumn Get Row |("SQL-getRow" SQL-getRow Query3 |("SQL-execQuery" SQL-execQuery ) = 1 |("SQL-exportRows" SQL-exportRows |("SQL-exportRows" "C:\tempf.tab") SQL-exportRows C:\tempf.tab| OnClose )3)!Z Z)3!BZc!) !BZR!) ORPTH FPTHAOMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks Clone MSPCA NAMEA Artworks Clone RPTHA Artworks Clone Macintosh HD Artworks Clone tFMP3FMP3 SQL Example OMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks Clone IRPTH MSPC FPTHAIMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks MSPCA NAMEA Artworks RPTHA Artworks alisA alisA FPTHA ZONE NAMEA Artworks ZONEA <RPTH alis FPTHA<Macintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:sql.txt MSPCA NAMEA sql.txt RPTHA ::sql.txt Macintosh HD sql.txt TEXTttxt FileMaker Pro 4.0 Folder <Macintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:sql.txt ~NAME FPTHA Macintosh HD:SQL Example:li MSPCA NAMEA RPTHA Macintosh HD Artworks tFMP3FMP3 SQL Example IMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks !RPTH MSPC FPTHA!Macintosh HD:SQL Example:Artworks MSPCA NAMEA Artworks RPTHA Artworks Macintosh HD Artworks tFMP3FMP3 SQL Example !Macintosh HD:SQL Example:Artworks PB 1400 Macintosh HD NAMEA Artworks.fp3 RPTHA ARTWORKS.FP3 SRPTA ARTWORKS.FP3 WSPCA D:\dev\SQL Example\ NAMEA li.fp3 RPTHA LI.FP3 SRPTA LI.FP3 WSPCA D:\dev\SQL Example\ NRPTH Macintosh HD FMP3FMP3 SQL Example Macintosh HD:SQL Example:li PB 1400 Macintosh HD HRPTH FPTHAHMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:li.fp3 MSPCA NAMEA li.fp3 RPTHA li.fp3 Macintosh HD li.fp3 FMP3FMP3 SQL Example HMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:li.fp3 FMRLA FMRLA ArtworksB Lines | Constant FPTHANMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:Artworks.fp3 MSPCA NAMEA Artworks.fp3 RPTHA Artworks.fp3 Macintosh HD Artworks.fp3 FMP3FMP3 SQL Example NMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:Artworks.fp3 Pro 3.0 - 4.0F! Pro 3.0 - 4.1M1 zondag maandag dinsdag woensdag donderdag vrijdag zaterdag januari februari maart april augustus september oktober november december 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter